
CREATE TABLE daycare.ReminderTimes
  (
   ReminderTimeId INT NOT NULL
                      PRIMARY KEY
                      IDENTITY(1,1)
 , ReminderId INT NOT NULL
 , ReminderTime TIME NOT NULL
 , AnsweredById INT
 , AnsweredTimeStamp DATETIME2
  )
ALTER TABLE daycare.ReminderTimes ADD CONSTRAINT FK_ReminderTimes_Reminder FOREIGN KEY (ReminderId) REFERENCES daycare.Reminders(ReminderId)
ALTER TABLE daycare.ReminderTimes ADD CONSTRAINT FK_ReminderTimes_Employees FOREIGN KEY (AnsweredById) REFERENCES daycare.Employees(EmployeeId)
GO